Correlation (fld, fld), Correlation (fld, fld, condFld), Correlation (fld, fld, condFld, cond)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Enables you to calculate the correlation of the specified fields (that is, the degree to which the fields vary in the same manner). For example:

Examples

The following examples are applicable to both Basic and Crystal syntax:

Correlation({Customer.CUSTOMER ID}, {Customer.CREDIT ID})

Calculates the correlation between the Customer ID and Credit ID fields.

Correlation({orders.CUSTOMER ID}, {orders.CREDIT ID}, {Customer.REGION})

Calculates the correlation between the Customer ID and Credit ID fields, for each region.

Correlation({orders.CUSTOMER ID}, {orders.CREDIT ID}, {Customer.REGION}, "monthly")

Calculates the correlation between the Customer ID and Credit ID fields for all the values within each Region group, for each month.

Note:    Using this function in a formula forces the formula to be evaluated at print time.

For more information on evaluation time considerations, see Evaluation Time functions.

Comments

The correlation will always be a number between -1 and 1, unless the correlation is undefined, in which case the function is assigned a null value (0). If the correlation is 0, the fields are uncorrelated.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com